Five Points to Business Intelligence
Flat Files, CSV, Excel, Access, Database, Web, Data Feeds, OData, Log Files, Application Data, Open Data
Data gets moved from Source to Destination via a transformation process where data is cleansed and business rules are applied. Data also gets Mashed up with other data sets.
Flat Files, CSV, Excel, Databases, Data Feeds, OData, Data Warehouses (Dim/Fact Tables)
Reports, Dashboards, Web Pages, Graphs, Charts, Scorecards, KPI, Drill Through, PDF, Email, Embedded, Mobile
Three Types of Business Intelligence
A. SQL-Server, Flat/Excel Files
C. Data Warehouse
D. SSAS, Tabular Models
E. Dashboards, SharePoint, Power View, Performance Point, SSRS Reports
2. Self Service
A. Variety of Data Sources
B. Power Query / Excel
C. Excel Tables
D. Power Pivot
E. Power View, Power Map
3. Big Data
A. Raw Text Files, Images, Zip Files
B. Map-Reduce, Hive, Pig
C. Output Files
D. Power Query --> Power Pivot --> Model OR SSIS --> SQL-Server
E. Power View, Performance Point, SSRS
1. On Premise
A. Physical Server
B. Virtual Machine
D. Hadoop HDFS Cluster
E. Parallel Data Warehouse
A. Azure Web Servers, Databases, Reporting Services (SSAS not there yet)
B. Azure VM
C. HD Insight (BlobStorage replaces HDFS)
Microsoft offers a tremendous variety of Business Intelligence Solutions. Many times, organizations will mix various offerings to suit their needs.
With that said, Microsoft will need to quickly identify a way to push software to their users. As they stated, software will be pushed through the Cloud first, allowing the community to sample and provide feedback. MS will then use that info to tailer the On Premise products.
As I've stated before, there are some vendors out there who produce quality products in their specific niche, but there aren't a lot, if any, vendors who offer such a variety of offerings across the entire gamut of Business Intelligence products.
I signed up for the Hortonworks Certified Associate exam last Thursday. Figured if I sign up, I'd have to take the test. And if I tak...
This blog post is in no way an attempt to steal other people's work. It's basically an conglomeration of notes from research I did...
Saw a post today on Twitter, " Microsoft releases CNTK, its open source deep learning toolkit, on GitHub " This is big news. Be...