News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful for handling structured data, i.e. data incorporating relations among entities and variables. SQL offers both a data definition language (DDL) and a data manipulation language (DML). The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control.
As the name implies, SQLite is a light weight transactional SQL database engine. It is open-source and free for use either for personal commercial. SQLite is widely used in mobile apps and many other desktop applications that need an internal light weight free SQL database. In this post I explain how to visualise SQLite data … Continue reading Visualise SQLite Data in Power BI
I’d like to thank you all for attending the webinar held on 30th September 2016. I talked about some amazing under cover aspects of Power BI Desktop model. In this session you learnt: how to find Power BI Desktop local port number how to connect to Power BI Desktop model from Excel and SQL Server … Continue reading Webinar Materials: Power BI Under the Hood
Update 2021 March: You can now export the data direct from Power BI Desktop using my tool, Power BI Exporter. Read more here. Update 2019 April: If you’re interested in exporting the data model from either Power BI Desktop or Power BI Service to CSV or SQL Server check this out. The method explained here … Continue reading Exporting Data from Power BI Desktop to Excel and CSV – Part 1: Copy & Paste and DAX Studio Methods