Dave on Data

The Dave on Data mission is to empower any professional (or team) with the DIY data science skills needed to unleash the power of AI technologies like Copilot in Excel.

What gets left out of the AI Hype Cycle is this:

AI will make you (or your team) wildly more productive.

**BUT**

You must have the requisite skills to make the most of AI.

**AND**

If these skills are lacking, you will not be able to recognize (and correct) the AI when it makes mistakes.

BTW - AI makes mistakes all the time.

Take Microsoft's Copilot in Excel AI as an example.

The "magical" scenarios where Copilot analyzes data using a few clicks and a couple of short prompts rely heavily on two things:

Python
Machine learning

Here's the thing, however. 

I've tested Copilot in Excel, which rarely generates the correct Python/machine learning code.

As the DIY data scientist, this is where you unleash Copilot's power.

I can teach you these DIY data science skills.

Regardless of role. Regardless of background.

Founder

TDWI

I develop and deliver live training experiences on data science topics such as data analysis and predictive analytics (e.g., machine learning). I focus on accelerating the data science journey for teams and organizations using a practical hands-on approach.

Training can be delivered virtually or in person with your team. The following offerings are certified by TDWI and can be taught using R or Python:

👉 Machine Learning Bootcamp
👉 Visual Data Analysis
👉 Linear/Logistic Regresion

💻 Learn more: https://daveondata.com/live-analytics-training

Data Science Consultant & Instructor

Schedulicity

VP of Analytics

Data Science Dojo

VP of Data Science

Microsoft

Sr. Director, BI and Analytics

Principal Program Manager

Sr. Director, Platform Architecture

Principal Architect

Ascentium Corp

Associate Partner, Solution Architect

Safeco Insurance

IT Architect

e-software, Inc.

Software Design Engineer

Programmer Analyst

I help ANY professional or team have more impact using data. Analytics demystified.

Want to differentiate yourself at work with Excel skills? Leaders aren't excited about this in 2025:

- Using PivotTables
- Knowing many Excel functions

You know what they're excited about: AI

And that means Copilot in Excel.

Here are the 4 steps to build the skills you need to master Copilot in Excel and impress your manager, business stakeholders, and executives:

1) Ignore "prompt engineering."
2) Learn Python.
3) Learn DIY data science.
4) Recognize hallucinations.

I want to help you own the future of Microsoft Excel.

I will help you get started today - for free.

Join 1,000s of professionals building skills for the future: 
https://daveondata.com/newsletter

David Langer

As an author, there's nothing quite like waking up to some good news from Amazon!

Back in May of 2023, I saw an early version of Python in Excel for the first time. I immediately knew I wanted to be a part of the most significant upgrade in Excel's analytics capabilities ever. 

And it didn't stop there.

When I first got access to Copilot in Excel's "advanced analysis" mode, I quickly saw Microsoft's vision for Excel's future. For professionals building Python analytics skills, the future of Excel lies in deep integration with Copilot AI to unleash the power of their data.

My book is the first step in building the skills for Excel's AI-powered future. It uses your existing knowledge of Excel to help you learn the Python foundation you need - fast.

If you're ready to make 2026 the year you embrace the power of Excel, AI, and data, you can pre-order my book here: https://lnkd.in/eQp4g5_d

#Excel #PythonInExcel #MicrosoftExcel

I help professionals and teams build better forecasts using machine learning with Python and Python in Excel.

Interesting behavior from Copilot in Excel. Just another example of how Python in Excel skills are part of Excel's AI-powered future.

I was working on the next issue of my LinkedIn newsletter, which will cover using AI to build better forecasts in Microsoft Excel, and asked Copilot to create a forecast for me.

I was surprised to see that Copilot didn't use Excel's FORECAST.ETS() function because that's the best way to build data-driven forecasts using native Excel features.

Instead, Copilot in Excel generated Python code in the background to build an ETS model similar to what would be produced from FORECAST.ETS() using Python's mighty statsmodels library.

BTW - I covered statsmodels in my last two LinkedIn newsletter articles.

I'm betting that the new Copilot in Excel Agent Mode will be able to manipulate worksheets (e.g., generating formulas) directly and will be able to generate forecasts using FORECAST.ETS().

However, I'm also betting the Agent Mode will eventually be smart enough to recognize when a better forecasting technique is available from Python and use that instead.

Which means that the AI-powered future of Microsoft Excel will belong to those professionals who develop Python skills.

Stay healthy and happy data sleuthing!

#Excel #PythonInExcel #MicrosoftExcel

Department of National Defence

* Main task is to assist Life Cycle Materiel Managers in over all supply chain, procurement and asset management 

* Continuous updates on internal accounting and supply chain database for DND ( CARDs)

* Basic to intermediate hardware & electronics troubleshooting of communication devices used by Canadian Armed Forces (CAF) & Department of National Defence ( DND) 

* Assists in management and configuration of inventory systems to be used by warehouse operations 

* Software upgrades of communications devices such as tactical radios, signals mechanisms and RF/HF devices

* Asists in coordination with defence and aerospace contractors such as: General Dynamics, L3 Harris, Thales & Boeing

* Provides monthly and bi weekly fundamental analysis of equipment

Life Cycle Material Management (LCCM) - Communications Security

Commissionaires Ottawa

* A decade of experience in a Security Operation Centre (SOC) dealing mainly with physical security & asset protection
* Physical Security 
* Basic Threat and Risk Assessments 
* Logistics & Administration (Federal Government Agencies)
* Pen Testing (Physical Security)
* Acted as Commissioner on Oaths for Criminal Injuries Boards 
* Special Events security

Security Operations Center Operator

Commissionaires Canada

* Power BI Reports Development 
* Develops visual reports, dashboards and KPI Scorecards 
* Utilize Power Query (M Language), DAX (Data Analysis Expressions) and Data Modelling 
* Prepares ad hoc reports that are utilized by various stakeholders 
* Majority of data sets are financial and HR Data

Data Analyst (Power BI Developer)

Veza Global

Responsible for analyzing HR data and creating various data visualizations. 

Main focus of HR data was on meeting specific metrics that are inline with specific cleint goals.

Contract Research Data Analytics Coordinator

Bell

* Performing reviews & updates of multiple data records
* A lot of data cleansing & data validation tasks of raw data
* Documentation of findings & insights regarding data anomalies and inconsistencies 
* Utilize excel , internal databases (MS-SQL) & statistics in over-all data analysis 
* Utilize common search engines and government websites to cross validate tabular data

Data QA &  Research Analyst

GrowPayment

* Actively Promote Stembis.com , our upcoming E-commerce platform for Cannabis-based products

* Use non-traditional marketing channels to create product awareness & market engagement 

*  Works closely with marketing managers & business dev't team

Blockchain Evangelist

Rideau Family Health Team

* Developed dashboards & reporting templates pertaining to  clinical data 

* Designed a fundamental data warehouse & entity-relational schema for the BI dashboard

* Data Wrangling, Data Analysis & Data Visualization using Sisense Analytics 

* Analyzed business processes & requirements

Business Intelligence Analyst (Contract)

SEO TWIST

I handle a minimum of 20 account on a weekly basis.  Client accounts do range form financial institutions to dental clinics, form large non-profit organizations to local fitness centers.

Majority of my tasks are done utilizing Google Adwords, Google Analytics, Facebook Banner Ads and a constant use of spreadsheets.

SEO & PPC Analyst Assistant

Rare Genomics Institute

I am part of a small team of User Experience (UX) Specialists that handles a variety of roles regarding mobile and web apps. 

My job roles ranges from :
1. Wire-framing and Prototyping 
2. User Research & Market Research ( Persona Creation)
3. Information Architecture (IA) and Site maps 
4. Usability Engineering 
5. Collaborative work with designers, developers and engineers 
6. Create and Analyze a Quarterly Competitive Analysis Report

User Experience (UX)  Designer

Doodles Academy

UX Researcher

Data Analysis | Business Intelligence | Marketing Analytics | Data Visualization

github: 
https://github.com/Frederick-Zoreta

Tableau Public: 
https://public.tableau.com/app/profile/frederick.zoreta.first


     I have been involved in the field of analytics and data visualization for several years. Currently I am a data analyst and utilize Power BI & Excel daily. I mainly deal with financial and HR data. Although I mainly use Power BI, I continue to immerse myself in Tableau for academic/ personal projects.

     Prior to my current role, I have created several dashboards for a non profit healthcare group. For that role I mainly used Sisense and SQL. 

     I have also been a digital marketer and a marketing data analyst a few years ago where I mainly utilized Google Data Studio, Google Analytics and Google Ads/ FB Ads. 


     Lifelong learner? Yes indeed. On a daily basis I immerse myself on online courses and boot camps that are highly focused on 
Data Visualization, Analytics and also ventured into Robotic Process Automation (RPA) and fundamental cloud computing. 

     A future plan is to be very competent in Power Automate and UIPath.

taplio

The Battle

David Langer

Frederick Zoreta

Followers

Posts

Engagements

Likes

Performance ScoreDavid Langer's LinkedIn Performance

Ready to grow your LinkedIn presence?

taplio

The Battle

David Langer

Frederick Zoreta

Followers

Posts

Engagements

Likes

Performance Score.css-goub6s{font-size:var(--chakra-fontSizes-md);font-weight:500;color:var(--chakra-colors-gray-600);display:block;margin-top:var(--chakra-space-1);}David Langer's LinkedIn Performance

Ready to grow your LinkedIn presence?

Performance ScoreDavid Langer's LinkedIn Performance