Microsoft access+Power BI

จากที่เคยเขียน Microsoft Access ในรูปแบบ CRM (Customer Relation Management) ในการบันทึกข้อมูลการติดต่อลูกค้า โดยมีการเก็บข้อมูลลูกค้า การติดต่อลูกค้า รวมถึงยอดขายในการสินค้า ของลูกค้าแต่ละราย ตาม Relations ของตารางตามนี้

ซึ่งจริง ๆ แล้ว ใน Microsoft access ก็ตอบโจทย์การ Query ข้อมูลได้ในระดับนึง แต่หลังจากที่ได้ศึกษา Power BI มาแล้วเลยลองมาออก Visualization ผ่าน Power BI กัน

Import Files เข้ามาใน Power BI

Microsoft access + PowerBI นำเข้าข้อมูลมาเรียบร้อย

Report Customize ที่หลากหลาย เอามาคำนวณ ออกแบบ Graph ได้ทันที

สามารถกดเลือก Filter ดูยอดขายตาม ระยะเวลาได้

ดูยอดขายด้านซ้าย ทำ Graph ด้านขวาแบบ Interactive ได้หลากหลายแบบ

ดูยอดขายแบบ Interactive มีกราฟหลากหลายให้ใช้งาน

สามารถทำ Map ในส่วนของลูกค้าที่อยู่จังหวัดไหนได้ด้วย

ประยุกต์ใช้ Microsoft Access + Power BI เพื่อได้ Visualization ที่สวยงาม

เป็นการต่อยอดที่ใช้ Power BI และ Microsoft Access ในการทำงานได้อย่างสมบูรณ์

ติดตามสาระดีๆ จากพี่อ้วน รวมถึงรับดูแล Social Network บริหารจัดการ Content ได้ที่
https://www.idea2mobile.com
Call : 0863863896 , 0866188111
Line : e21eqg
email address : anantachai@idea2mobile.com

Webmaster
Anantachai ittiworapong

[gs-fb-comments]

By admin

ชื่อเล่น พี่อ้วน ล้มลุกคลุกคลาน ทางด้าน Digital Online ทั้งงานหน้าบ้านและหลังบ้านมาหลายปี เริ่มตั้งแต่ตั้งไข่ กับ Taradsolution เลยมาจนธุรกิจรถเช่าจนทำ SEO ติดอันดับ 1 ด้วย Keywod เช่ารถยนต์ เรื่อยมาจนถึงธุรกิจนำเข้าสมาร์ทโฟน Wiko สร้าง Brand และ ยอดขายมาเป็นอันดับ 6 ของประเทศไทย ในระยะเวลา 3 ปี ตอนนี้เปิดรับงานวิเคราะห์หา Insight Data โดยการใช้ Social Listening | Admin Page | Servey ออนไลน์ รายละเอียดเพิ่มเติมใน www.idea2mobile.com ติดต่อได้ที่ 0863863896

131 thoughts on “ประยุกต์ใช้ Microsoft Access + Power BI เพื่อได้ Visualization ที่สวยงาม”
  1. Oh my goodness! Incredible article dude! Thanks, However I am going through issues with your RSS. I don’t know why I can’t subscribe to it. Is there anybody else getting identical RSS problems? Anybody who knows the solution will you kindly respond? Thanx!!

  2. Fantastic website you have here but I was curious about if you knew of any community forums that cover the same topics talked about in this article? I’d really love to be a part of online community where I can get responses from other knowledgeable individuals that share the same interest. If you have any recommendations, please let me know. Kudos!

  3. Hiya very nice website!! Guy .. Beautiful .. Amazing .. I will bookmark your web site and take the feeds also? I am glad to seek out numerous useful information here in the publish, we need develop more strategies in this regard, thank you for sharing. . . . . .

  4. Hi, i read your blog occasionally and i own a similar one and i was just wondering if you get a lot of spam feedback? If so how do you reduce it, any plugin or anything you can suggest? I get so much lately it’s driving me insane so any assistance is very much appreciated.

  5. I know this if off topic but I’m looking into starting my own blog and was wondering what all is required to get set up? I’m assuming having a blog like yours would cost a pretty penny? I’m not very internet savvy so I’m not 100% sure. Any tips or advice would be greatly appreciated. Appreciate it

  6. Hey this is somewhat of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding know-how so I wanted to get advice from someone with experience. Any help would be greatly appreciated!

  7. Howdy! This is kind of off topic but I need some help from an established blog. Is it very hard to set up your own blog? I’m not very techincal but I can figure things out pretty fast. I’m thinking about creating my own but I’m not sure where to start. Do you have any points or suggestions? Cheers

  8. With havin so much content and articles do you ever run into any problems of plagorism or copyright violation? My site has a lot of completely unique content I’ve either created myself or outsourced but it looks like a lot of it is popping it up all over the web without my agreement. Do you know any techniques to help protect against content from being ripped off? I’d genuinely appreciate it.

  9. Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your webpage? My blog site is in the very same area of interest as yours and my visitors would truly benefit from a lot of the information you present here. Please let me know if this okay with you. Cheers!

  10. You can definitely see your expertise in the article you write. The world hopes for more passionate writers like you who aren’t afraid to mention how they believe. All the time go after your heart.

  11. Howdy! I’m at work browsing your blog from my new iphone 3gs! Just wanted to say I love reading your blog and look forward to all your posts! Keep up the outstanding work!

  12. great post, very informative. I wonder why the other experts of this sector do not realize this. You should continue your writing. I am sure, you have a huge readers’ base already!

  13. Pretty section of content. I just stumbled upon your web site and in accession capital to assert that I acquire in fact enjoyed account your blog posts. Any way I’ll be subscribing to your augment and even I achievement you access consistently rapidly.

  14. Hello there! This post couldn’t be written any better! Reading this post reminds me of my good old room mate! He always kept talking about this. I will forward this post to him. Pretty sure he will have a good read. Thanks for sharing!

  15. No matter if some one searches for his necessary thing, thus he/she needs to be available that in detail, so that thing is maintained over here.

  16. Unquestionably consider that that you stated. Your favourite justification appeared to be at the net the simplest thing to take note of. I say to you, I definitely get irked whilst other people consider worries that they plainly do not recognise about. You controlled to hit the nail upon the top as smartly as defined out the whole thing with no need side effect , folks can take a signal. Will likely be back to get more. Thank you

  17. all the time i used to read smaller articles which also clear their motive, and that is also happening with this piece of writing which I am reading at this time.

  18. I think this is one of the most significant information for me. And i’m glad reading your article. But want to remark on few general things, The website style is perfect, the articles is really nice : D. Good job, cheers

  19. Can I simply say what a relief to discover someone who truly knows what they’re talking about on the internet. You definitely understand how to bring an issue to light and make it important. More and more people have to read this and understand this side of the story. I was surprised that you’re not more popular since you certainly have the gift.

  20. I think what you postedtypedbelieve what you postedwrotesaidthink what you postedtypedbelieve what you postedtypedWhat you postedtyped was very logicala bunch of sense. But, what about this?think about this, what if you were to write a killer headlinetitle?content?wrote a catchier title? I ain’t saying your content isn’t good.ain’t saying your content isn’t gooddon’t want to tell you how to run your blog, but what if you added a titlesomethingheadlinetitle that grabbed people’s attention?maybe get people’s attention?want more? I mean %BLOG_TITLE% is a little vanilla. You ought to look at Yahoo’s home page and watch how they createwrite post headlines to get viewers to click. You might add a related video or a related pic or two to get readers interested about what you’ve written. Just my opinion, it might bring your postsblog a little livelier.

  21. I’ve been exploring for a little bit for any high-quality articles or blog posts in this kind of space . Exploring in Yahoo I eventually stumbled upon this web site. Reading this info So i’m satisfied to show that I have a very good uncanny feeling I came upon exactly what I needed. I such a lot unquestionably will make certain to don?t put out of your mind this site and give it a look on a constant basis.

  22. Have you ever considered about including a little bit more than just your articles? I mean, what you say is fundamental and all. However just imagine if you added some great pictures or video clips to give your posts more, “pop”! Your content is excellent but with images and clips, this website could certainly be one of the most beneficial in its niche. Superb blog!

  23. Normally I do not read article on blogs, however I wish to say that this write-up very pressured me to try and do so! Your writing taste has been amazed me. Thank you, quite great article.

  24. Usually I do not read article on blogs, however I wish to say that this write-up very forced me to take a look at and do so! Your writing taste has been amazed me. Thank you, quite great article.

  25. You really make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand. It seems too complicated and very broad for me. I am looking forward for your next post, I will try to get the hang of it!

  26. You can definitely see your enthusiasm in the article you write. The world hopes for more passionate writers like you who aren’t afraid to mention how they believe. Always go after your heart.

  27. The other day, while I was at work, my sister stole my iphone and tested to see if it can survive a thirty foot drop, just so she can be a youtube sensation. My iPad is now broken and she has 83 views. I know this is entirely off topic but I had to share it with someone!

  28. Pretty section of content. I just stumbled upon your web site and in accession capital to assert that I acquire in fact enjoyed account your blog posts. Any way I’ll be subscribing to your augment and even I achievement you access consistently rapidly.

  29. You can definitely see your enthusiasm in the article you write. The world hopes for more passionate writers like you who aren’t afraid to mention how they believe. Always go after your heart.

  30. You can definitely see your enthusiasm in the article you write. The arena hopes for more passionate writers like you who aren’t afraid to mention how they believe. Always go after your heart.

  31. I’m not sure where you are getting your info, but good topic. I needs to spend some time learning more or understanding more. Thanks for great information I was looking for this information for my mission.

  32. Хотите получить идеально ровный пол в своей квартире или офисе? Обратитесь к профессионалам на сайте styazhka-pola24.ru! Мы предоставляем услуги по устройству стяжки пола в Москве и области, а также гарантируем доступные цены и высокое качество работ.

  33. Позвольте себе быстрое и качественное оштукатуривание стен. Откройте для себя современные методы на нашем сайте mehanizirovannaya-shtukaturka-moscow.ru

  34. I don’t even know how I ended up here, but I thought this post was good. I don’t know who you are but definitely you are going to a famous blogger if you are not already 😉 Cheers!

  35. Сдайте все трудности процесса оштукатуривание стен профессионалам на mehanizirovannaya-shtukaturka-moscow.ru. Вы в хороших руках.

  36. Hi there! I could have sworn I’ve been to this website before but after browsing through some of the posts I realized it’s new to me. Nonetheless, I’m definitely pleased I found it and I’ll be bookmarking it and checking back frequently!

  37. First off I want to say fantastic blog! I had a quick question in which I’d like to ask if you don’t mind. I was curious to know how you center yourself and clear your thoughts before writing. I have had a hard time clearing my mind in getting my thoughts out. I do enjoy writing but it just seems like the first 10 to 15 minutes are usually wasted just trying to figure out how to begin. Any suggestions or tips? Thank you!

  38. I’m really enjoying the design and layout of your blog. It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Exceptional work!

  39. Hello there I am so thrilled I found your blog page, I really found you by error, while I was searching on Digg for something else, Regardless I am here now and would just like to say thanks a lot for a remarkable post and a all round thrilling blog (I also love the theme/design), I dont have time to go through it all at the minute but I have book-marked it and also included your RSS feeds, so when I have time I will be back to read much more, Please do keep up the superb jo.

  40. Hey just wanted to give you a quick heads up and let you know a few of the images aren’t loading correctly. I’m not sure why but I think its a linking issue. I’ve tried it in two different internet browsers and both show the same results.

  41. I like the valuable information you provide in your articles. I will bookmark your weblog and check again here frequently. I am quite certain I will learn lots of new stuff right here! Good luck for the next!

  42. Nice post. I learn something new and challenging on blogs I stumbleupon every day. It will always be helpful to read content from other writers and practice a little something from their websites.

  43. I don’t even know the way I stopped up here, however I thought this submit used to be good. I don’t recognise who you’re however definitely you are going to a famous blogger in the event you are not already. Cheers!

  44. Please let me know if you’re looking for a article author for your site. You have some really great posts and I think I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some articles for your blog in exchange for a link back to mine. Please send me an e-mail if interested. Cheers!

  45. You really make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand. It seems too complicated and very broad for me. I am looking forward for your next post, I will try to get the hang of it!

  46. Hey there, I think your blog might be having browser compatibility issues. When I look at your blog in Safari, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, very good blog!

  47. I was wondering if you ever considered changing the page layout of your site? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having one or two images. Maybe you could space it out better?

  48. I’d like to thank you for the efforts you have put in writing this website. I am hoping to see the same high-grade blog posts from you in the future as well. In fact, your creative writing abilities has motivated me to get my own blog now 😉

  49. Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet my newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.

  50. I believe what you postedwrotesaidthink what you postedwrotethink what you postedwrotethink what you postedtypedsaidWhat you postedwrotesaid was very logicala ton of sense. But, what about this?think about this, what if you were to write a killer headlinetitle?content?typed a catchier title? I ain’t saying your content isn’t good.ain’t saying your content isn’t gooddon’t want to tell you how to run your blog, but what if you added a titleheadlinetitle that grabbed a person’s attention?maybe get a person’s attention?want more? I mean %BLOG_TITLE% is a little vanilla. You might look at Yahoo’s home page and watch how they createwrite post headlines to get viewers to click. You might add a related video or a related picture or two to get readers interested about what you’ve written. Just my opinion, it might bring your postsblog a little livelier.

  51. When someone writes an post he/she maintains the idea of a user in his/her mind that how a user can know it. Thus that’s why this post is perfect. Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *