Hialeah Technology Center

601 West 20 st

Hialeah, Fl 33010

Phone: 305-925-1260

Web: www.hiatec.org

Email: jcarballo@hiatec.org

 

Instructor: Juan Carballo

Web: http://hialeahoficios.com

 

 

 

Hialeah Technology Center HIATEC is a nonprofit corporation established in the City of Hialeah for economic development of the business community.

 

 

Business Intelligence Introduction

 

1. Getting Started with Business Intelligence Tools.

         Understanding BI

         Enabling Component Object Model (COM) add-ins for Power Pivot and Power View

         Installing Power Query

Videos:

Quizzes:

2. Using Power Query to Get Data

         Searching for online data with Power Query

         Transforming Data

         Inserting custom columns

         Connecting to data sources

Videos:

Quizzes:

3. Modeling Your Data with Power Pivot

         Using Excel tables

         Using Power Queries

         Understanding relationships

         Creating relationships between tables

         Using big database tables

 

Videos:

Quizzes:

4. Enhancing PivotTables and PivotCharts with Power Pivot

         Creating a PivotTables and PivotVharts

         Adding slicers and timelines

 

Videos:

Quizzes:

 

5. Creating and Formatting Power View Reports

         Understanding Power View 

         Creating and using a table visualization

          Changing a table and  Adding data to a visualization

         Applying filters

 

Videos:

Quizzes:

 

6. Data Mining Introduction

         Data preparation

         Data modeling

        Table analysis tools

 

Videos:

Quizzes: