Video

Datawarehousing Concepts Basics (Fact and Dimension Table)

Post author By Tech Coach
Post date January 24, 2022
22 Comments on Datawarehousing Concepts Basics (Fact and Dimension Table)

Fact, Dimension, Star Schema may sound little tricky specially to people who have never worked on a Datawarehouse, This video explains them in a simple manner with a real world example
#DAtawarehouse #datawarehousingconcepts #Techcoach

source

Tags 10minute mail, api power bi, arduino, arduino ide, azuredatastudio, bigdata, bool mysql, business analytics, business intelligence, cheap vps, code python, data, Data Analysis, data analytics, data base file, data driving, data mining, Data Warehouse, data warehousing and data mining, databases, datacleaning, datacollector, datafabric, datahub, datalake, datalineage, datamanagement, datamigration, dataprocessing, dataquality, datasteward, datastudio google, datavisualization, datawarehouse, datax, datetime sql, dbeaver, dbschema, Dimension, edw, email services, etl, etl tools, eurostat data, eurostat database, Fact Table, free vps, general, general energy, general mor, gmail log in mail, gnu gpl, gnu radio, google bi, google datas, google datastudio, google gmail, gpl v3, graphics, hardware, host server free, hostdomain, hotmail sign, influxdb, kaggle titanic, knime, mail gmail, mail microsoft, mail si, mail temporary, mariadb, masterdata, microsoft sql server, mongodb db, mongoexport, mongoimport, mssql, mysql datetime, mysql export database, mysql log, mysqlworkbench, networking, nosql, odbc, olap, open office apache, opensource, operating systems, outlook web, phpmyadmin, postgre, postgresql copy, postgresql jsonb, programming, python fn, python zen, query sql, rawgraphs, row data, sign mail gmail, small data, smtp, software, spark apache, sql, sql server, sql server data type, sql server management studio, sql type, sqldbm, Star, studio google, system administration, tera term, the hosting, tutor python, un comtrade, uncomtrade, vlan, vps, vps host, wan, webhosting, webmail, webscraper, wifis

22 replies on “Datawarehousing Concepts Basics (Fact and Dimension Table)”

Superbly explained within couple of minutes

When you are manager of data warehouse , how you keep the data validate in term of secure data of validation ?

Ans….

Please make a video on explaining these questions in the last as there is no next session video is available

Thanks a lot. Good explanation!!

Simplified

Well done.

nice work.
great effort

Too great vedios

Excellent bro ! Simply superb explanation.

Hi Vivek Nice Effort on this.
let me know in which table we can pass the query Dimension or Fact Table or Both hope vl get ans soon…

Bad audio, but excellent content!

I have seen many people explaining different concepts, but your explanation is very precise to the point and very understandable and easy to learn. Thank you man!!!

The Best.

thanks for the real time examples, very helpful

I have a few questions in regards to creating dimension and fact tables based on the scenario… Like for Order process, Shipping the order process,calculating the remaining quantity of each product in the warehouse and in some cases the customer returns goods…So in total there are 4 processes, therefore, I need to have 4 fact tables..Am i right?

It's OLAP not OLTP

We are expecting more videos

Good video.

The content is good but the voice is so annoying to listen to. May be you can make it a bit clear and smooth, it sounds like a broken mic has been used. No offense but its difficult to keep listening to. I need to see more but I cant see yours because of poor voice quality, switching to somebody else just for that. Hope you will fix that. Thanks though

Thanks Nice video

good video

22 replies on “Datawarehousing Concepts Basics (Fact and Dimension Table)”

Leave a Reply Cancel reply