Level 7 – Microsoft Power BI Desktop and Power BI Services

16 hours in-person or online $595
Each trainee receives a PDF of every Microsoft DAX formula, definition, syntax with examples
We provide computers to use with on-site training at your workplace and at our site. Everyone receives a paperback workbook

Contact the instructor, Jeremy Nathan at 865-282-1895 or email him at jnathan@jncomputertraining.com to sign up!

Part 1 – Importing data

Data analysis using Excel Pivot Tables with dashboards and slicers
Query SQL Server databases
Power Query to import individual Excel files from different folders
Importing CSV files and refreshing queries to automatically import data

Part 2 – Cleanse Data

Formatting, cleaning and transforming data to make it ready to analyze
Importing reports and combining columns
Using Excel tables and creating automatic and manual relationships
Making a calendar and other data tables and importing lists of business data

Part 3 – Model Data

Performance KPI Indicators for business activities
Create DAX (Data Analysis Expressions) calculated columns and measures
Analyzing 7-day, 10-day, 15-day, 30-day rolling averages in sales, inventory, labor hours, etc.
Analyzing year-to-year and month-to-month change in sales, expenses, labor hours, by products, departments, vendors, customers, etc.
Analyzing month-to-date, quarter-to-date, and year-to-date sales, expenses, labor hours
Analyzing percentage change of market share of your company year-to-year
Analyzing expansion of sales to new customers by units and dollar amounts
Analyzing repeat customer sales and periods where those customers had no sales
Financial report authoring
Advanced business ratios and dynamic ranking

Part 4 – Visualize Data

Format Pivot Tables and Pivot Charts for reports
Slice and filter, group and summarize data using Pivot Tables
Timelines in Pivot Tables
Create measures from Pivot Tables
Microsoft Power BI Desktop – Data Visualization with Dashboards

Contact Us

excel power bi