Business Intelligence
Leverage the power of SQL and Excel to Perform Business Analysis
Course Description
Three key efforts are essential to effectively transform data into actionable information: retrieving data with SQL, presenting data with Excel, and understanding statistics as the foundation of data analysis. Data mining focuses on these topics and shows you how SQL and Excel can be used to extract business information from relational databases. Students begin by taking a look at how data is central to the task of understanding customers, products, and markets, and he then goes on to show you how to use that data to define business dimensions, store transactions about customers, and summarize important data to produce results. Each module explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what you can expect the results to look like. Throughout the course, critical features of Excel are highlighted, interesting uses of Excel graphics are explained, and dataflows and graphical representations of data processing are used to illustrate how SQL works.
Course Type: Instructor Led |
Full Course Outline |
Other Microsoft Certified Courses |
Select a Class Date and Location then Call 208.327.0768
| Location | Start Date |
| Boise | December 17 |
| Boise | April 27 |
We Meet your Training Needs!
To request a date for this course call, 327.0768
today. We will contact you as soon as the class is scheduled.
Private and Onsite Events
We also coordinate private events for your team at your facility or ours. To plan a private training event,
please call 327.0768.
More Learning Opportunities
In addition to our classroom training, we offer ExecuTrain Virtual Campus for self paced online learning.