EXCEL BUSINESS INTELLIGENCE BOOT CAMP

If you regularly work with Excel, doing Management Level Reports and Data Analysis, then we guarantee that attending this course will change your life.

Learn to create advanced Business Intelligence dashboards using Excel Pivot Tables, Pivot Charts, Power Pivot, Power Query and Power BI.

Learning these tools will put you in the top 1% of Excel users worldwide and give you skills that will increase your productivity and enable you to produce impressive, informative, useful dashboards and reports in minutes.

For more information, get in touch now...

info@datainsighttraining.com
+44 330 223 5910

---

Course Content

Day 1:  Pivot Tables:

• Working with Pivot Tables
• Understand trends by Year, Quarter, Month, Week and Weekday
• Create Top and Bottom 10 analysis
• Easily calculate percentage contributions, running totals and difference from calculations
• Create Sparklines to visualise trends
• Learn to use buckets and groupings for frequency analysis
• Learn to use slicers to create interactive dashboards
• Create Pivot Charts.

 
Day 2:  Power Pivot: 

• Analyse more than 1 million rows of data
• Load data into Power Pivot; Filter data with Slicers
• Easily create Relationships between tables of data
• Create easy to use Dashboard view from Power Pivot
• Learn the principles of the DAX formula language to create powerful new calculations
• Create powerful new DAX measures in Pivot Tables such as year-to-date, month-to-date, previous month etc
• Create dashboards with Power Pivot data.

 
Day 3:  Power Query and Power BI: 

• Introduction to Power Query
• Benefits of Power Query
• Loading data into Power Query (Microsoft Access Tables, CSV Files, Online Data Sources, Modifying Tables)
• Merging Data
• Appending Data
• Unpivoting Data
• Using the Group function
• Creating Custom Calculations
• Introduction to Power BI
• Power BI Desktop
• Creating Reports in Power BI
• Different Methods of Aggregation
• Tables and Cards
• Filtering

 
Day 4:  Power BI:

• Visualisations
• Graph Options
• Trend Analysis - Time Intelligence
• Additional Graph Types
• Creating an Interactive Dashboard
• Enhancing Power BI - DAX Formulas
• DAX Measures
• Relationships
• Enhancing Your Power BI Data

---

Course Requirements

A laptop with either Excel 2013 with Power Pivot and Power Query, Excel 2016 with Power Pivot, Office365 with ProPlus or Office 2019.  You should have a good understanding of Excel and the principals of operating Excel as well as working with data.

---

Course Duration

This is a 4 day course.

---

Course Price

£990 per delegate (UK Mainland)
Please note there is a required minimum of 4 delegates
Price valid until 31 December 2022 ​