Data Science and Data Engineering - Chesapeake Data Science LLC

I am working on for the past few years on Data Science and Data Engineering and Tableau. Built a new website : www.chesapeakedatascience.com to impart my knowledge in the above field.

We are providing in-person 8 boot camp on Data Science and Data Engineering at Columbia, MD, USA and a 2/3 day boot camp on Tableau. This training covers in-depth and 100 % hands-on.

I spent a innumerable hours in preparing the course content to provide training at the highest standards.

I attended multiple trainings from various organizations.

1. Big Data (five module) from University of California, USA

2. Data Science ( Nine module) from Microsoft, USA

3. Data Science (Nine module) from Johns Hopkins University, USA

4. Data Science and Data Engineering - 5 day bootcamp from Data Science Dojo, USA

5. Data Insights from MIT, USA

I have multiple certifications and the most recent on is from Tableau.
  Tableau Desktop Qualified Associate and obtained a score 97%

I teach and train people at work on Tableau to build Dashboards/Story. See more details on the website:   www.chesapeakedatascience.com

I am professional photographer and avid cycling enthusiast.
   sivagirumala.squarespace.com

 Data warehouse / BI:

This blog is about building a Data warehouse / BI project to show the full life cycle of a data warehouse project.

 I selected one of the popular data sets on www.census.gov site i.e. US County Business Patterns (http://www.census.gov/econ/cbp/) for this project.

Explore:

• Explore/Identify the Data 

Loading DBs:

• Load the Staging DB
• Normalize and Load Staging DB to Relational DB 
• Load the DW DB

Analysis Services:

• Creating a Cube
• Cube - Partitions and Aggregations
• PowerPivot

Reports:

• Report Template, Report based on analysis Services, Drillthrough and Pie charts
• Reports - Drilldown + Subreport
• Reports-Sparklines, Databars and Indicators

Naming conventions:

• SSIS
• Data warehouse

Platform: 

                 SQL Server 2012

                 SQL Data Tools
                 Data size: 30+ Million rows

Please watch the videos in High resolution: 720P

Watch for the posts in coming days!!!